using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace prDe_Tai.TruyXuat
{
    class LayDuLieuCoDieuKien
    {
        public void LayDuLieuTheoChuDe(string loaiphanmem, string chude)
        {
            OleDbCommand com = new OleDbCommand();
            com.CommandType=CommandType.Text;
            com.CommandText="select tenphanmem from DanhSachPhanMem where loaiphanmem=@loaiphanmem and chude=@chude";
            com.Parameters.Add("@loaiphanmem", OleDbType.BSTR).Value = loaiphanmem;
            com.Parameters.Add("@chude", OleDbType.BSTR).Value = chude;
            
        }
        public void layDuLieuTheoTenPhanMem(string tenphanmem)
        {
            OleDbCommand com = new OleDbCommand();
            com.CommandType = CommandType.Text;
            com.CommandText = "select * from DanhSachPhanMem where tenphanmem=@tenphanmem";
            com.Parameters.Add("@tenphanmem", OleDbType.BSTR).Value = tenphanmem;
            
        }
    }
}
